<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_goods_attr`;");
E_C("CREATE TABLE `ecs_goods_attr` (
  `goods_attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `attr_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attr_value` text NOT NULL,
  `attr_price` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`goods_attr_id`),
  KEY `goods_id` (`goods_id`),
  KEY `attr_id` (`attr_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_goods_attr` values('1','1','1','翡翠类','0');");
E_D("replace into `ecs_goods_attr` values('2','1','2','手镯','0');");
E_D("replace into `ecs_goods_attr` values('3','1','3','其他','0');");
E_D("replace into `ecs_goods_attr` values('4','1','4','新玉','0');");
E_D("replace into `ecs_goods_attr` values('5','1','5','碧玉','0');");
E_D("replace into `ecs_goods_attr` values('14','2','9','国家级证书','0');");
E_D("replace into `ecs_goods_attr` values('13','2','8','复检后再付款','0');");
E_D("replace into `ecs_goods_attr` values('12','2','7','其他','0');");
E_D("replace into `ecs_goods_attr` values('11','2','6','糯种','0');");
E_D("replace into `ecs_goods_attr` values('15','2','10','CMA CAL CNAS/CNAL','0');");
E_D("replace into `ecs_goods_attr` values('16','2','11','未镶嵌','0');");
E_D("replace into `ecs_goods_attr` values('17','2','12','荔尚','0');");
E_D("replace into `ecs_goods_attr` values('18','2','13','A2314','0');");
E_D("replace into `ecs_goods_attr` values('19','2','14','500-1000','0');");
E_D("replace into `ecs_goods_attr` values('20','2','15','手镯','0');");
E_D("replace into `ecs_goods_attr` values('21','3','2','其他','0');");

require("../../inc/footer.php");
?>